1. Pointer KPIs: Creating Upward and Downward Pointer for the KPIs took me time to find out the workaround, I had to create 2 measures one for the pointer to be up or down, the second measure was for the coloring condition, and it worked great
2. Incomplete dataset: the data set was incomplete; I had to fill up the gaps as certain accidents didn’t have data and the other complementary information required to produce an informative dashboard.
3. Dax and measure: I had to create a series of Dax measures and calculated columns to build this dashboard; lots of research helped me too in achieving this thing.
Lead more on common challenges encountered while building a dashboard in power bi and how to overcome them
1. Pointer KPIs: Creating Upward and Downward Pointer for the KPIs took me time to find out the workaround, I had to create 2 measures one for the pointer to be up or down, the second measure was for the coloring condition, and it worked great
2. Incomplete dataset: the data set was incomplete; I had to fill up the gaps as certain accidents didn’t have data and the other complementary information required to produce an informative dashboard.
3. Dax and measure: I had to create a series of Dax measures and calculated columns to build this dashboard; lots of research helped me too in achieving this thing.
Lead more on common challenges encountered while building a dashboard in power bi and how to overcome them
